How to get a list of all tables in Oracle?

Question

Aryan Kumar · Answer

There are a few ways to get a list of all tables in Oracle. Here are a few of the most common methods:
Using the all_tables view: The
all_tables view is a data dictionary view that contains information about all of the tables in the database. You can use the
SELECT statement to select the table_name column from the
all_tables view to get a list of all tables.
SQL
SELECT table_name
FROM all_tables;
Using the user_tables view: The
user_tables view is a data dictionary view that contains information about all of the tables in the schema that the user is currently logged in to. You can use the
SELECT statement to select the table_name column from the
user_tables view to get a list of all tables in the current schema.
SQL
SELECT table_name
FROM user_tables;
Using the DBA_TABLES view: The
DBA_TABLES view is a data dictionary view that contains information about all of the tables in the database, including tables that are owned by other users. You can use the
SELECT statement to select the table_name column from the
DBA_TABLES view to get a list of all tables in the database.
SQL
SELECT table_name
FROM DBA_TABLES;
Which method you use will depend on your specific needs. If you need a list of all tables in the database, then you can use the
all_tables or DBA_TABLES views. If you only need a list of tables in the current schema, then you can use the
user_tables view.

forum

How to get a list of all tables in Oracle?

Utpal Vishwas

Can you answer this question?

1 Answers

Liked By